package com.kly.user.db.dao;

import com.fqgj.common.api.Page;
import com.fqgj.common.base.BaseMapper;
import com.kly.user.db.dbo.UserMessageReportDBO;
import com.kly.user.db.entity.UserMessageReportEntity;

import java.util.Date;
import java.util.List;

/**
* User: linqu
* Date: 2023-09-22
* Time: 17:47:36.382
*/

public interface UserMessageReportDao extends BaseMapper<UserMessageReportEntity> {

    List<UserMessageReportEntity> queryUserMessageReport(Date beginDate);

    List<UserMessageReportEntity> sumUserMsgReport(Date beginDate);

    int removeTodaySumReport(Date beginDate);

    UserMessageReportEntity getByChatterUserCode(String chatterUserCode, Date beginDate);

    List<UserMessageReportDBO> getReplyReport(String chatterUserCode, String nickName, Date startDate, Date endDate, Page page);

    UserMessageReportDBO getReplyReportTotal(String chatterUserCode, String nickName, Date startDate, Date endDate);

    UserMessageReportDBO sumTodayReport();

    Integer getReplyReportCnt(String chatterUserCode, String nickName, Date startDate, Date endDate, Page page);

    UserMessageReportDBO getReplyReportTotalByChatterUserCode(Integer date, String chatterUserCode);

    /**
     * 获取建联数与承接数
     */
    UserMessageReportDBO getContactNum(Integer date, String chatterUserCode);

}